#!/bin/bash
now=$(date "+%Y%m%d")
dataPath=\"/user_clicks/${now}/clicklog.dat\"
dt=\"${now}\"
sql=load data inpath ${dataPath} into table user_clicks partition(dt=${dt})
echo $sql
/opt/lagou/servers/hive-2.3.7/bin/hive -f "$sql"